Caso 21 By juan-castro82211

A University Speyer is a international college from Colombia, consists of multiple faculties which are composed of various institutes. Each faculty and each institute has a name. An address is known for each institute. Each faculty is led by a dean, who is an employee of the university. The total number of employees is known. Employees have a social security number, a name, and an email address. There is a distinction between research and administrative personnel. Research associates are assigned to at least one institute. The field of study of each research associate is known. Furthermore, research associates can be involved in projects for a certain number of hours, and the name, starting date, and end date of the projects are known. Some research associates hold courses. Then they are called lecturers. Courses have a unique number (ID), a name, and a weekly duration in hours.